Attribute | Description | Physical Name | Domain | Data Type | Foreign Key Table |
CustomerMembeshiprProgramAccountID (FK)(PK) | Token ID for a CustomerMemberProgramAccount. | ID_CT_MBR_PRGM_ACNT | Identity | integer | CustomerMembershipProgramAccount(LE_CT_MBRSHP_PRGM_ACNT) |
CustomerRewardProgramTierCode (FK)(PK) | A code that represents the relative value of a given CustomerRewardProgramTier | CD_CT_RWD_PRGM_TIER | Code | varchar(20) | CustomerMembershipEarnedRewardTier(CO_CT_MBRSHP_ERN_RWD_TIER) |
MembershipProgramID (FK)(PK) | Token ID for a CustomerRewardProgram instance. | ID_CT_MBRSHP_PRGM | Identity | integer | CustomerMembershipEarnedRewardTier(CO_CT_MBRSHP_ERN_RWD_TIER) |
LevelNumber (FK)(PK) | A whole number that establishes the relative value of a membership program level. The higher the value, the greater the level and its associated rewards and, where applicable, fees. | IC_LV_NMB | Number | integer | CustomerMembershipEarnedRewardTier(CO_CT_MBRSHP_ERN_RWD_TIER) |
StatusSequencNumber (PK) | A sequence number used to capture a customer's program account reward tier status change, This attribute allows multiple occurences of a tier status to be stored over time for time series analysis of customer activity. | AI_STS_SQN_NMB | Identity | integer | |
EffectiveDate | Date a CustomerRewardAccount becomes active. | DC_EF_DT | EffectiveDate | date | |
ExpirationDate | Date a CustomerRewardProgramAccount becomes inactive | DC_EP_DT | ExpirationDate | date | |
StatusCode | Current status of this CustomerRewardProgramAccount Valid values are A Active I Inactive | CD_STS | Code2Status | char(2) | |